
CREATE TABLE daycare.NotificationSettings
  (
   NotificationSettingId INT NOT NULL
                             IDENTITY(1,1)
                             PRIMARY KEY
 , FamilyId INT NOT NULL
 , NotificationTypeId INT NOT NULL
 , ReceivePostal BIT NOT NULL
 , ReceiveEmail BIT NOT NULL
 , ReceivePrinted BIT NOT NULL
  )
ALTER TABLE daycare.NotificationSettings ADD CONSTRAINT FK_NotificationSettings_Families FOREIGN KEY(FamilyId) REFERENCES daycare.Families(FamilyId)
ALTER TABLE daycare.NotificationSettings ADD CONSTRAINT FK_NotificationSettings_NotificationTypes FOREIGN KEY(NotificationTypeId) REFERENCES daycare.NotificationTypes(NotificationTypeId)
GO